Backup/Restore (Available only in Full Version & only for MySQL, PostgreSQL and SQLite)

A secure and reliable server is closely related to performing regular backups as failures will probably occur sometimes - caused by attacks, hardware failure, human error, power outages, etc.

Navicat allows you to backup/restore all tables and records, views, stored procedures and events for your MySQL, PostgreSQL and SQLite databases. Backup can be invoked from the command line, which makes it possible to schedule backups between databases/schemas.

Just simply click to open an object pane for Backup. A control-click displays the popup menu or using the object pane toolbar below, allowing you to create new, restore, extract and delete the backup.

Create Backup

To create a new backup

Edit Backup

To change the name of the backup

Delete Backup

To delete a backup

Restore Backup

To restore a backup to an existing database

To restore a backup to a new database

Extract SQL

To extract backup to sql file

Achieve Backup Information

To achieve a backup information (Name, File Size and Update Time etc)